enq: KO - fast object checkpoint
Short Description
Enqueue wait. Multiple Object Checkpoint.
Additional Information​
An enqueue is a wait for a resource held by another.
KO enqueues are for ‘multiple object checkpoints’.
When an object is read by a direct path read, the buffer cache is not used, so the checkpoint process is instructed to checkpoint that object to ensure consistency before the read.
This wait is associated with full table scans on tables with dirty blocks.
How to reduce this wait​
Consider managing the amount of updates vs the number of table scans in your system.
Additional Links​
Oracle Docs - Oracle Enqueue Names
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.